﻿CREATE PROCEDURE [dbo].[Hogar_BeneficioPrevisional_ObtenerTodos]   
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   obtener todos los beneficios previsionales 
-- Returns:    BeneficioPrevisional
/*****************************************************************************************************************************************/ 
	
	SELECT  [BeneficioPrevisionalId],
			[Descripcion]
	FROM	[dbo].[BeneficioPrevisional] WITH (NOLOCK)
	ORDER BY [Descripcion]
	
END